Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

4 Subjects

Week 2 Data Model Assignment

Week 2 Data Model Assignment

Q Choose a data model by clicking on one of the links below: • Restaurant OrdersDownload Restaurant Orders For the data model that you chose, copy and paste that data model graphic into your paper using MS Word. (You can copy the data model graphic by right-clicking on it. On PCs, the keyboard combination of ctrl-V is the shortcut command for pasting.) In the MS Word document, list the following: 1. all the entities 2. all the attributes in each entity 3. the primary key for each entity 4. all the foreign keys 5. all the relationship cardinalities between entities (e.g., a professor can teach one to many classes; an individual class is taught by one and only one professor) 6. for each relationship between entities, specify the name of the attribute in one entity that will be used to match to an attribute in a related entity, including the specific attribute name in the second entity that is used for the matching. For instance, in a school data model: “The Student_ID attribute in the Registered_Class entity is used to match to the Student_ID attribute in the Enrolled_Student entity.” Submit your MS Word document. Resources: • Textbook: Module 3 – The Relational Data Model • Video: Module 3 – Relational Database Tables and Their Characteristics (3:13 min.) • Video: Module 3 – Relational Database Keys (1:48 min.) • PowerPoint: Module 3 Review charts • Textbook: Module 4 – Entity Relationship (ER) Modeling • Video: Module 4 - Entity Relationship Diagrams: Part I - Entities and Attributes (3:46 min.) • Video: Module 4 - Entity Relationship Diagrams: Part II Identifiers (1:19 min.) • Video: Module 4 - Entity Relationship Diagrams: Part III Relationships (3:54 min.) • Video: Module 4 - Entity Relationship Diagrams: Part IV Relationship Degrees (2:13 min.) • Video: Module 4 - Entity Relationship Diagrams: Part V Associative Entities (1:19 min.) • PowerPoint: Module 4 Review charts Rubric Weekly Course Assignment Rubric Weekly Course Assignment Rubric Criteria Ratings Pts This criterion is linked to a Learning OutcomeCritical Thinking 20 pts Main points are concise, clear and well developed. Evidence and detail provide superior support for the assignment. 18 pts Main points are clear and well developed. Evidence and detail provide strong support for the assignment. 16 pts Main points are clear and developed. Evidence and detail adequately support the assignment. 14 pts Presents an incomplete analysis of the issues identified and demonstrates an inadequate understanding of the topic(s) and issue(s). 20 pts This criterion is linked to a Learning OutcomeAnalysis 20 pts Makes appropriate and powerful connections between the issues identified and the strategic concepts studied in the reading; Demonstrates complete command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with strong arguments and evidence; presents a balanced and critical view; interpretation is both reasonable and objective. 18 pts Makes appropriate connections between the issues identified and the strategic concepts studied in the reading; Demonstrates good command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with reasons and evidence; presents a fairly balanced view; interpretation is both reasonable and objective. 16 pts Makes appropriate but somewhat vague connections between the issues and concepts studied in the reading; Demonstrates limited command of the strategic concepts and analytical tools studied. Supports diagnosis and opinions with limited reasons and evidence; presents a somewhat one-sided argument. 14 pts Makes little or no connection between the issues identified and the strategic concepts studied in the reading. Supports diagnosis and opinions with few reasons and little evidence; argument is one-sided and not objective. 20 pts This criterion is linked to a Learning OutcomeKnowledge of Content 20 pts Exceeds requirements in demonstrating strong knowledge of content and depth. 18 pts Knowledge of content and depth are appropriately reflected in the assignment. 16 pts Supplements case study with limited research into the present situation of the company; provides limited documentation of sources consulted. 14 pts Some knowledge of content and depth are evident. 20 pts This criterion is linked to a Learning OutcomeAssignment Purpose 20 pts Presents detailed, realistic, and appropriate recommendations clearly supported by the information presented and concepts from the reading. 18 pts Work is accurately detailed. The weekly assignment requirements are adequately addressed. 16 pts Work reflects the assignment purpose. The weekly assignment requirements are somewhat addressed. 14 pts Work rarely reflects the assignment purpose. The weekly assignment requirements are rarely addressed. 20 pts This criterion is linked to a Learning OutcomeNo Description 20 pts Writing demonstrates a sophisticated clarity, conciseness, and correctness; includes thorough details and relevant data and information; extremely well-organized. Uses APA guidelines accurately and consistently to cite sources. 18 pts Writing is accomplished in terms of clarity and conciseness and contains only a few errors; includes sufficient details and relevant data and information; well-organized. Uses APA guidelines with minor violations to cite sources. 16 pts Knowledge of content and depth are satisfactory. 14 pts Writing is unfocused, rambling, or contains serious errors; lacks detail and relevant data and information; poorly organized. Uses APA guidelines with major violations to cite sources. 20 pts Total Points: 100

View Related Questions

Solution Preview

All the entities: The entities that are present in the following ERD are as follows: 1. Customer 2. Product 3. Order 4. Order Status 5. Order items All the attributes in each entity The attributes of customer entity include customer ID, first name of the customer, last name of the customer, address line 1, address line 2, city, state and postal code. The attributes of product entity include product ID and product name. The attributes of order entity include order ID, order date, order instructions. The attributes of order status entity include order status ID, status name.